Executive Summary 3


PROBLEMS THAT OCCURRED DURING THE PROJECT:
1.    Created a function for cleansing data to correct junk string values for names of cities and places 

 

2.    PRINT 'InitCap() function to cleanse source data as below: 

PRINT 'new-yORK ==> ' + dbo.InitCap('new-yORK')

PRINT 'new/york ==> ' + dbo.InitCap('new/york')

PRINT 'new yORK ==> ' + dbo.InitCap('new yORK')

PRINT 'quad cities, ia/il ==> ' + dbo.InitCap('quad cities, ia/il')

 

3.    InitCap() function to cleanse source data as below:

new-yORK          ==> New-York

new/york             ==> New/York

new yORK           ==> New York

quad cities, ia/il           ==> Quad Cities, Ia/Il

 

http://blog.decisivedata.net/blog/cleaning-messy-data-sql-part-3-sql-functions-clean-strings

Cleaning Messy Data in SQL, Part 3: SQL Functions to Clean Strings